[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
----------------------------------------------------------------------------
QUERY() User query condition builder
----------------------------------------------------------------------------
Usage QUERY_COND = QUERY(<# FIELDS>,<FIELD ARRAY>,
<FIELD DESCR ARRAY>)
Params <#fields> -number of fields in array
<fieldname array> -array of fields to use
<fielddesc array> -array of field descriptions
(all optional)
Example
...
USE CUSTOMER
private flds[3],fdes[3]
flds[1] = "fname"
flds[2] = "lname"
flds[3] = "mi"
fdes[1] = "First Name"
fdes[2] = "Last Name"
fdes[3] = "Middle Initial"
qcond = "lastname > 'CCCC' "
filt = query(3,flds,fdes)
set filter to &filt
...
or
...
USE CUSTOMER
looker = query()
locate for &looker
...
Returns QUERY CONDITION STRING
ALSO MAKES VARIABLE 'QUERY_EXP' PUBLIC. This contains
the current query expression, which is retained
between calls of query, and is looked for by some of
the other SuperFunctions.
Note Query could bomb out, by the user attempting to restore
a query condition from the disk that does not match
the dbf- although the dbf name is stored to disk and
along with the Query, and only stored queries with the
matching dbf name are allowed to be restored.
INTERNAL FUNCTIONS:
Q_ALT_BLD() Q_CTL_() Q_OP_D() Q_DUMMY()
Q_ALT_GET() Q_CURR_GET() Q_FLD_GET() Q_OPS_GET()
QU_ANDOR() Q_SAY_CON
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson